Import Cost Data from Both Deltek Cobra and Work Authorization Docs (WAD)

Use the Cost Data Import wizard to import cost data from both a Deltek Cobra data file and Work Authorization Documents (WAD).

To import cost data from a Deltek Cobra data file and work authorization documents (WAD), complete the following steps:

  1. Export the Deltek Cobra data file from Cobra (see the Cobra help for instructions).
  2. On the S1 // Projects tab, do one of the following:
    • In the Projects pane, right-click on the project and select Import Cost Data.
    • In the Get External Data From menu group, click Deltek Cobra and click Cost Data.
  3. On the first page of the Cost Data Import wizard, select Import both Cobra and WAD data and click Next.
  4. Browse to and select a cost data file. The file that you import must have a .dcde extension.
  5. Select the cost project that you want to import and click Next.
  6. Select the WBS, OBS, Work Package, and Control Account fields that map to the cost data.
    1. WBS/OBS — Select the fields that map to the cost data.
    2. Use WBS and OBS as Control Account Keys — If this check box is selected, the activity maps to a work package if the Work Package, WBS, and OBS fields all match. If the check box is not selected, the activity maps to a work package if the Work Package fields match, and the control account key fields match to the control account ID.
    3. Work Package — Select the field that maps to the cost data.
    4. Control Account — Select the field that maps to the cost data.
    5. Click Next.
  7. Browse to and select the work authorization document and click Next. The file that you import must have a .xls or .xlsx extension.
  8. Select the worksheet that contains the WAD information.
  9. Select the WAD column that matches the cost project control account ID and click Finish.

Acumen imports the cost data. The import progress displays at the bottom of the window.